Christian G. ✭✭✭✭✭✭

Overview

Overview

Roles	Member
Badges	12

About Me

About Me

Area of Expertise	Automation
About Me	Smartsheet Self taught
How I Use Smartsheet	Everyday, for everything

Analytics

111

Posts

165

Visits

1.3k

Points

Sep 14, 2022

Join Date

Oct 26, 2023

Last Active

Reactions

• Insightful 2

  2
• Vote Up 23

  23
• Awesome 12

  12

• Activity
• Discussions5
• Comments106

• Re: Trigger workflow based on time of day a request is received

  Christian G.

  11/07/22
  I would extract the hour from the "created date" column with : =iferror(value(left(right([created date]@row,8),2)),value(left(right([created date]@row,7),1))) Then you can run an ourly &quo…
  1 ·

• Re: IF Formulas including Blanks and AND / OR

  Christian G.

  11/07/22
  How about that? =IF([Date Complete]@row <= IF(isblank([Renegociated date]@row),[Agreed Deadline]@row,[Renegociated date]@row), "Yes", "No")
  1 ·

• Re: Removing ' from cells

  Christian G.

  11/07/22
  IF you make a column with =VALUE([Imported data]@row) as formula, it willconvert the text to number. you can then copy/paste that elsewhere
  1 ·

• Re: Hi Everyone--I am trying to create a multiple IF statement that is coming an "or" and a "contains" .

  Christian G.

  11/04/22
  @gnomer70 Let's break it done so it's easier to parse ! if(OR(Temp@row = “Ambient”, Temp@row = “None Required”),"WIP", else...) if(Temp@row = "2-8c cooler", "COL", else.…
  1 ·

• Re: Automation condition equal to (find and replace) ?

  Christian G.

  11/03/22
  You can use "helpers" column, and have an automation that will (re)move the failed row to the to an archive sheet. the helper column would set a checkbox to True if the same part number wit…
  1 ·

Next